{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":74,"n_cols":28,"rows_kept":74,"cut":false,"hidden":false,"merged":[[30,3,30,6],[32,8,32,9],[0,1,0,7],[1,1,1,2],[10,1,10,2],[18,1,18,2],[0,8,0,27]]}
[null,null,null,null,null,null,null,null,"Options Theoretical Calculator"]
[null,"Input Parameters"]
[null,"Option","Put",null,{"$f":"IF(C3=\"Call\",\"c\",\"p\")","v":"p"},null,null,null,{"$f":"IF(I32=1,\"Theoretical Price\",IF(I32=2,\"Delta\",IF(I32=3,\"Gamma\",IF(I32=4,\"Vega\",IF(I32=5,\"Theta\",\"Rho\")))))","v":"Theoretical Price"}]
[null,"Undelying Price",410]
[null,"Strike Price",400]
[null,"DTE (days)",100]
[null,"Risk-free rate",0]
[null,"Volatility",0.5]
[null,"Dividend yield",0]
[]
[null,"Theoretical Values"]
[null,"Theoretical Price",{"$f":"BSM($E$3,\"p\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":37.351315396720196}]
[null,"Delta",{"$f":"BSM($E$3,\"d\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":-0.41090938620035866}]
[null,"Gamma",{"$f":"BSM($E$3,\"g\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":3.6248445584321147E-3}]
[null,"Vega",{"$f":"BSM($E$3,\"v\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":0.83470735653758665}]
[null,"Theta",{"$f":"BSM($E$3,\"t\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":-0.20867683913439672}]
[null,"Rho",{"$f":"BSM($E$3,\"r\",$C$4,$C$5,($C$6/365),$C$7,$C$8,$C$9)","v":-0.56390181846264986}]
[]
[null,"IV Calculation"]
[null,"Option",{"$f":"$C$3","v":"Put"}]
[null,"Market Option Price",8]
[null,"Implied Volatility",{"$f":"IF($C$20=\"Call\",ImpliedCallVolatility($C$4,$C$5,($C$6/365),$C$7,$C$21,$C$9),ImpliedPutVolatility($C$4,$C$5,($C$6/365),$C$7,$C$21,$C$9))","v":0.14621734619140625}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,50]
[null,null,null,"Chart Settings"]
[null,null,null,"Underlying price range:",null,"Time range:",null,null,1,{"$f":"IF(I32=1,\"p\",IF(I32=2,\"d\",IF(I32=3,\"g\",IF(I32=4,\"v\",IF(I32=5,\"t\",\"r\")))))","v":"p"},{"$f":"TODAY()+K33","v":"2023-09-02"},{"$f":"TODAY()+L33","v":"2023-09-22T21:10:35.294"},"2023-10-13T18:21:10.588","2023-11-03T15:31:45.882","2023-11-24T12:42:21.176","2023-12-15T09:52:56.471","2024-01-05T07:03:31.765","2024-01-26T04:14:07.059","2024-02-16T01:24:42.353","2024-03-07T22:35:17.647","2024-03-28T19:45:52.941","2024-04-18T16:56:28.235","2024-05-09T14:07:03.529","2024-05-30T11:17:38.824","2024-06-20T08:28:14.118","2024-07-11T05:38:49.412","2024-08-01T02:49:24.706","2024-08-22"]
[null,null,null,"Minimum :",200,"Start point :",10,null,"Underlying Price",null,{"$f":"$G$33","v":10},{"$f":"K$33+($G$34-$G$33)/17","v":30.882352941176471},{"$f":"L$33+($G$34-$G$33)/17","v":51.764705882352942},72.64705882352942,93.529411764705884,114.41176470588235,135.29411764705881,156.17647058823528,177.05882352941174,197.9411764705882,218.82352941176467,239.70588235294113,260.58823529411762,281.47058823529409,302.35294117647055,323.23529411764702,344.11764705882348,{"$f":"$G$34","v":365}]
[null,null,null,"Maximum :",600,"End point :",365,null,{"$f":"J34/$J$45-1","v":0.57894736842105265},{"$f":"$E$34","v":600},{"$f":"BSM($E$3,$J$32,$J34,$C$5,(K$33/365),$C$7,$G$35,$C$9)","v":3.6995829372206499E-6},{"$f":"BSM($E$3,$J$32,$J34,$C$5,(L$33/365),$C$7,$G$35,$C$9)","v":5.6347785514058391E-2},{"$f":"BSM($E$3,$J$32,$J34,$C$5,(M$33/365),$C$7,$G$35,$C$9)","v":0.51250748688946501},1.4848001577956147,2.8515939121020004,4.4844272884690142,6.290218082345902,8.2060329744411007,10.189650793092746,12.212505625643217,14.255039059104703,16.303711766925431,18.349072448510597,20.38449183979543,22.405318307706153,24.408304741548946,26.391213085873531,28.352537251481934]
[null,null,null,"What to show: ",601,"Volatility Impact: ",{"$f":"$I$30*0.01","v":0.5},null,0.52631578947368429,{"$f":"J34-($E$34-$E$33)/20","v":580},{"$f":"BSM($E$3,$J$32,$J35,$C$5,(K$33/365),$C$7,$G$35,$C$9)","v":2.9090991783001273E-5},0.11806262665636025,0.82407246982728921,2.1252235462914584,3.8193463625982957,5.7514284510688398,7.8229713356963586,9.9726413719903846,12.161793515636887,14.365669099385855,16.568181770353817,18.758788327025428,20.930566871448946,23.079006971162158,25.201229984333821,27.295475789636583,29.36075843506913,31.396631241342718]
[null,null,null,null,null,null,null,null,0.47368421052631571,560,2.0867486897263587E-4,0.24172562413099108,1.3102167700510599,3.0216219387357555,5.0933200053528225,7.3544570922135364,9.7088477637713311,12.10152311941691,14.500310263039665,16.886047000417307,19.247250252945662,21.577104654149494,23.871700784930781,26.128971583356375,28.348032566921304,30.52876300985784,32.671534915737837,34.777034859850716]
[null,null,null,null,null,null,null,null,0.42105263157894735,540,1.3509271385783311E-3,0.48237700661949923,2.0571724622434679,4.2640469731035324,6.7589227556244396,9.3723582654486535,12.020207477238216,14.659186149918625,17.266581860478539,19.830566275346627,22.345302167091873,24.808344373066134,27.219200012931324,29.578503372227487,31.887530307869795,34.147906770820896,36.361431555656807,38.529967885504419]
[null,null,null,null,null,null,null,null,0.36842105263157898,520,7.8015309720452786E-3,0.93562163561016298,3.1852377495231678,5.9671732743049475,8.9197194578405359,11.897916210936515,14.840526810846271,17.721293916432288,20.529733244314357,23.262849089027455,25.921288959531466,28.507457614644721,31.024555525186685,33.476077068553138,35.865546915556919,38.196383678416467,40.471833005252122,42.694938999799021]
[null,null,null,null,null,null,null,null,0.31578947368421062,500,3.9690916324625736E-2,1.7586787339662884,4.8563417235580388,8.2731292773706997,11.698568770311581,15.038327171043406,18.264594831494122,21.372745447424748,24.366667338970771,27.253232601001073,30.040076301657805,32.734688676874882,35.344060893470001,37.874572306465097,40.331983509967586,42.721473867725393,45.047695253529852,47.314828988252899]
[null,null,null,null,null,null,null,null,0.26315789473684204,480,0.1755938682273035,3.1938497400717338,7.2793012205714689,11.352405543506151,15.237401853948384,18.914706610095394,22.398002966580677,25.707222314084333,28.861686375431276,31.878462481044579,34.772201855698057,37.555389063701512,40.238672235177248,42.831173187704806,45.340751646374727,47.774222336945172,50.137530986092003,52.435896554230339]
[null,null,null,null,null,null,null,null,0.21052631578947367,460,0.66680593578410097,5.5864187415840405,10.709621234767198,15.401448337436733,19.694905497830419,23.660184782794246,27.355631294161157,30.825991714305189,34.105543153209595,37.220938021336053,40.193272894452122,43.039536346913309,45.773624540468717,48.407063810609856,50.949533856677164,53.409253348443968,55.793268981773139,58.107675591421014]
[null,null,null,null,null,null,null,null,0.15789473684210531,440,2.1479127353151171,9.3826887849295701,15.439867050941928,20.635351949841777,25.24129537735044,29.416099641510471,33.25880233578377,36.835728518307548,40.193742471265409,43.367367427645149,46.382889394479321,49.260864335927323,52.017724952540874,54.666852098456872,57.219313422952979,59.684387228360634,62.069943161183602,64.382724778280959]
[null,null,null,null,null,null,null,null,0.10526315789473695,420,5.8169947222918665,15.090212005899275,21.776778045930229,27.274212749759158,32.04943551453951,36.325823089263992,40.23077881168868,43.845114285938308,47.223903114263834,50.406679811718448,53.422965394189617,56.295497209293814,59.042231136049764,61.677642422440016,64.213603941201455,66.659998447826325,69.025157151489623,71.316181280890419]
[null,null,null,null,null,null,null,null,{"$f":"J44/$J$45-1","v":5.2631578947368363E-2},400,13.202911157325133,23.188154833964774,30.003318965742153,35.52245625046362,40.281880892294453,44.52590695391541,48.390354706427445,51.960005612364739,55.292004735857518,58.427043141100796,61.395317845450336,64.219973171467814,66.91921386346155,69.507667556766421,71.997298906423907,74.398043529121139,76.718260095336632,78.965060546338975]
[null,null,null,null,null,null,null,null,0,380,25.267011297397744,33.997286468555444,40.328481684039161,45.542017572017073,50.074095062844464,54.134566344908961,57.84346438714266,61.27706058892349,64.487397236026709,67.511865738231421,70.378405581183529,73.108547403046401,75.719301422352402,78.224385393141432,80.635054225758239,82.960678671784024,85.209160047193677,87.387234439247237]
[null,null,null,null,null,null,null,null,-5.2631578947368474E-2,360,41.51276007636784,47.55290606561806,52.834533846367947,57.422664808474764,61.515177215762094,65.238076487736095,68.67304741358052,71.875896513587094,74.886561852270745,77.73472702514465,80.443141981803336,83.029687573644679,85.508715464515632,87.891950192502065,90.189115754674731,92.408382701708518,94.556694678528629,96.640011820784196]
[null,null,null,null,null,null,null,null,-0.10526315789473684,340,60.285249381151232,63.54907114134636,67.438259760169331,71.155581492788798,74.628845423166922,77.876446765720459,80.927877630173583,83.810146732636156,86.545803138727081,89.153307670925159,91.647786871080939,94.04172871716861,96.345542017093379,98.567988731993864,100.7165150048896,102.79750522958943,104.81647846407895,106.77824167160276]
[null,null,null,null,null,null,null,null,-0.15789473684210531,320,80.031752733059648,81.406942987173011,83.885073378846414,86.618503421896548,89.358855016249265,92.030661736834702,94.611675865195252,97.098196357939798,99.493333871176617,101.80258608080086,104.03206104132624,106.18775094149993,108.27524871477601,110.29965784517208,112.26558680797405,114.1771790941803,116.0381562028239,117.8518631906023]
[null,null,null,null,null,null,null,null,-0.21052631578947367,300,100.00184211333129,100.45267484708779,101.78783090386781,103.58059929100187,105.56387629193674,107.614605803893,109.67448501974894,111.71487635027549,113.72158818184957,115.68784600320771,117.61083348586814,119.48989701088021,121.32557301555806,123.11904342777001,124.87182336015027,126.58557923986751,128.26202227060082,129.90284637862177]
[null,null,null,null,null,null,null,null,-0.26315789473684215,280,120.00004794430231,120.11268790329893,{"$f":"BSM($E$3,$J$32,$J50,$C$5,(M$33/365),$C$7,$G$35,$C$9)","v":120.70469058008467},121.73132549680969,123.02627814111955,124.47510412666082,126.00879568974347,127.58589100364534,129.18102397491239,130.77838860525512,132.36801042050993,133.94356737471003,135.50107897706255,137.03809533833217,138.55318259522429,140.04558900947913,141.5150240558948,142.96150981211991]
[null,null,null,null,null,null,null,null,-0.31578947368421051,260,140.00000046523212,140.02044170413257,140.22958838099413,140.72948184620898,141.47652626937614,142.40278842178404,143.45295053083066,144.58706445783253,145.77705704427208,147.00321431532657,148.25158792550988,149.51221557459689,150.77791901518682,152.0434893467054,153.30512886107601,154.5600635454735,155.80627032439031,157.04228246878969]
[null,null,null,null,null,null,null,null,-0.36842105263157898,240,160.00000000133144,160.00250319139167,160.059068280764,160.25924347953938,160.62999890049622,161.15430200789433,161.80353930780447,162.55034363469443,163.37192976330243,164.25022843990956,165.17115700679722,166.12378828329699,167.09963256705447,168.09206903041391,169.09591018824818,170.10707227462308,171.12232631201374,172.13910960713449]
[null,null,null,null,null,null,null,null,-0.42105263157894735,220,180.00000000000082,180.00018731276313,180.0113062019594,180.07446234149972,180.22737952183959,180.48276487302184,180.83654040492635,181.27757470817608,181.79300256780681,182.37054676690542,182.99934837701727,183.67013507478799,184.37512271557404,185.10782759605584,185.86286515506757,186.63576479409366,187.42281015707286,188.22090561260015]
[null,null,null,null,null,null,null,null,-0.47368421052631582,200,200,200.00000750086954,200.00148684198277,200.01632831239624,200.06639587934083,200.16946001485834,200.33400157109347,200.56118360764691,200.84789604228953,201.18898275942044,201.57857419419332,202.01080635002791,202.48017380737977,202.981678254131,203.51086797050979,204.06382219397867,204.63711003296237,205.22773985760222]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]